Check Register Comments

Query is missing BatchNum from check table, this is the file number for ACH transfer.

You may also want to limit the export to a specific bank account , adding MASTERBR and G_MAJ in the where clause To limit for a specific accounting period you can use AN ( Fiscal year ) and MOIS ( Fiscal Period )

All the viewer of checks have excel export, but probably not with this level of detail, exported data depends on Context.

Accounting->Bank->Cash Receipts/Disbursement Accounting->Bank->Generate Bank File Accounting->General Ledger  ( from Bank Account )->Transaction details Accounting->General Ledger->Transaction ( Specific journal C/D Cash Disbursement ) Bank Reconciliation

I have been tasked with creating an export that would mimic a check register. I started by looking at what was in MD Accounting. See PDF Is there an export option directly from MD Accounting? See XLSX I have some columns that I do not understand Could you please let me know what these columns are and give me any feedback you would like on the query as a way to create an exportable check register?

Thanks,

Art

See: O:\ACCTGRP\InformerLinks\Multidev\Multidev - Check Register.iqy